Spliting Variable

[drewduncan]

Hi:

I am import a CSV file line by line.
I store the whole line in a variable.

Variable may look like:
56,HighStreet,London

Is there a function that can split the variable to the commas e.g. can i 'grab' then 56, then the HighStreet then London?

Any help appreciated

 

[SQLBI]

Hi,

Are you doing this in VBA? I assume you are if you're using a variable.

The

Split

function creates an Array which holds sections of a tring Variable, in your example

Public Sub TestSplit()

Dim strString As String 'Your variable value
Dim strArray As Variant 'Array to hold the elements of the variable
Dim intX As Integer

strString = "56,HighStreet,London" 'Define the variable value

strArray = Split(strString, ",") 'Breakdown the variable at each occurance of ','

For intX = LBound(strArray) To UBound(strArray) 'Iterate through the elements of the variable

    Debug.Print strArray(intX) 'Shows each element in the Immediate window. You code to use the variable element goes here.

Next intX

End Sub

Hope this helps

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[SQLBI]

Are you doing this in VBA? I assume you are if you're using a variable.

And the fact that you're in the Microsoft: Access Modules (VBA Coding) Forum is also a bit of a give away!!



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[drewduncan]

Thanks Leigh:

Works great. Had a couple of functions trying to do the same thing but getting compicated.

Cheers