PureBasic Forums - English

any thoughts on how to separate the information within this file

file data withing the lines below:
--------------------------------------------------------------------------------------------------------------------------
PROJCS["NAD_1927_StatePlane_Ohio_South_FIPS_3402",GEOGCS["GCS_North_American_1927",DATUM["D_North_American_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER["Standard_Parallel_1",38.73333333333333],PARAMETER["Standard_Parallel_2",40.03333333333333],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Foot_US",0.3048006096012192]]
--------------------------------------------------------------------------------------------------------------------------

example of data that need to be striped out
PROJCS["NAD_1927_StatePlane_Ohio_South_FIPS_3402",

i need info within the "" along with the header PROJCS for example

Your one example is not enough for us to understand what the other separated datasets should be. Show the whole line split-up as required.

Search the forum for a Split() function and load the file into a string or array per line break.
Then parse the resulting string repeatedly until you have your desired fields and values.
This assumes you know the common pattern or delimiter.

It would help if you describe exactly your 'FROM' & 'TO'.
I see the 'FROM', but only a portion of the 'TO'.
Are the '-------' lines included in the file as separators?

Doesn't it work by simply using the "," as seperator?

So you use "Countstring" to find how many comma seperated fields there are. Then look through them with the "Stringfield" command. On the resulting string, you use "Stringfield" again with "[" as seperator to get the leading token ("PROJCS") and "Stringfield" with " as seperator to get the value ("NAD_1927_StatePlane_Ohio_South_FIPS_3402").

Obviously if there are commas inside the value fields too, you need to handle that case.

yeah that's kinda the issues im having problems trying to figure out.

Ramihyn_ wrote:Doesn't it work by simply using the "," as seperator?

So you use "Countstring" to find how many comma seperated fields there are. Then look through them with the "Stringfield" command. On the resulting string, you use "Stringfield" again with "[" as seperator to get the leading token ("PROJCS") and "Stringfield" with " as seperator to get the value ("NAD_1927_StatePlane_Ohio_South_FIPS_3402").

Obviously if there are commas inside the value fields too, you need to handle that case.

ehowington wrote:yeah that's kinda the issues im having problems trying to figure out.

Simple rule - quotation marks come in pairs, if you have a string which contains an uneven number of quotation marks, you are inside a string-field and need to apply a fix (like injecting a comma and appending the next field). This is a simplified way of doing it, a more correct way would be to make a proper loop which seperates the comma fields manually and uses a running counter of "quotation marks". Splitting at commas then only happens if the quotation mark counter is even.