Separating feild

[Anonymous]

hi,

i have number field like this : 015821,015822.015823...

tha last number (1) , means the position .

i want to separt the last number and make a new field that i can work with' exm:

i want to count how many positions i have for 01582   .

how do i do it ?

thanks'

yarin.

[amars]

Hi Yarin,

Make use of SubField(String, ',') function, which will separate all the delimiting Person with Position into separate records.

SubField(String,',') As Person_Position

Load

     Person_Position,

     Mid(Person_Position,1, Len(Person_Position)-1) As Person,

     Right(Person_Position,1) As Position

Resident TableName

Now all your data is available use distinct count to identify the Positions for each person.

Thanks

[sujeetsingh · Accepted solution]

Hi

Now if you want the last digit you can use this function as

=right(FieldName,1)   this will always give you the first digit from right side.

Now you can check for 01582 as

=if(left(Fieldname,5)='01582',1,0)

This will give value 1 when condition is true else 0.

Hope it helps you.

[#4]

SEE ATTACHEMENT