String Splitting in Foxpro Visual 9

Question

I have a column of strings separated by comma.

Example: City, Zipcode

I want to make a column with only city populated so everything before the comma.

How has anyone else accomplished this? I know with Foxpro you can usually accomplish the same task various ways. Any help would be appreciated.

EDIT: SOLUTION

GETWORDNUM(FIELD,1,",")

This worked to give the text string before the comma from the column FIELD.

score 4 · Answer 1 · answered Jan 12 '21 at 22:08

4

The easiest way to do that is to use STREXTRACT(). ie:

lcColumnData = "City, Zipcode"

? STREXTRACT(m.lcColumnData, "",",")

answered Jan 12 '21 at 22:08

Cetin Basoz

22,495
3
31
39

score 2 · Answer 2 · answered Feb 15 '21 at 22:25

2

STORE ALINES(aCZ, "Atlanta, 30301", ",") TO iCZ

City = aCZ[1]
ZipCode = aCZ[2]

?City
?ZipCode

answered Feb 15 '21 at 22:25

Keht

57
9

1

a verbal explanation is often helpful – con Feb 16 '21 at 01:32

Polymath · Answer 3 · 2021-10-20T07:33:19.570

0

Try this:

str = "City, Zipcode"

*initialize the column value leftcol
leftcol = ''   
*find comma position
pos = At(',', str)
Do Case
  Case pos > 1 
    * there is a comma and something before that. take everything before that pos
    leftcol = Left(str, pos-1)

  Case pos = 1
    * first char is comma
    leftcol = ''

  Otherwise
    *there is no comma. take the whole string
    leftcol = str
EndCase

edited Oct 20 '21 at 07:33

answered Oct 20 '21 at 07:27

Polymath

630
7
11

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Oct 20 '21 at 07:40

String Splitting in Foxpro Visual 9

3 Answers3