How to separate parts of the string, using 'left' and 'index' ?

[#1]

i have alphanumeric values in a column like this ,

5. very satisfied

4. satisfied

5. very satisfied

4. satisfied

3. neutral

2. dissatisfied

1. very dissatisfied

3. neutral

2. dissatisfied

how to separate numeric and char part in two different columns using 'left' and 'index' function ?

Thanks.

[florentina_doga]

=subfield(5. very satisfied,'.',1) !

[florentina_doga]

=subfield('5. very satisfied','.',1)

[Anonymous]

Or use the subfield() function.

     =trim(subfield('5. very satisfied',.,1))

     =trim(subfield('5. very satisfied',.,2))

[giakoum · Accepted solution]

a small improvement. If you add the space in the delimiter, you can omit trim :

subfield('5. very satisfied','. ',1)

subfield('5. very satisfied','. ',2)

[buzzy996]

ya,subfield() is the right function here!

[ankit777]

hi

try like this

for numeric part

=left(fieldname,1)

for string

=SubField(fieldname,' ',2)

[#8]

Thanks All

[vishsaggi]

Hey Ajinkya,

Just another way using Left() and Right() functions.

Number: = Left(StatusName, 3)

Text:      = Right(Status, Len(Status) - Len(Left(Status,3)))

Thanks,
V.

[#10]

The use of index is then also possible :

Number: = Left(StatusName, INDEX(StatusName, '.') - 1)

But subfield is a better solution!