Link to home
Start Free TrialLog in
Avatar of emi_sastra
emi_sastra

asked on

FORMULA TO SEPARATE DATA

Hi All,

I have a column with data :

'Lembur@171.00 Jam x@'

I want to separate it into 2 formula :

1. fmlDesc = 'Lembur'
2. fmlQty =  '171.00 Jam x'

How could I do it ?

Thank you.
Avatar of Mike McCracken
Mike McCracken

Try this

fmlDesc
Split({YourField},"@")[1]

fmlQty
Split({YourField},"@")[2]

mlmcc
Avatar of emi_sastra

ASKER

Hi  mlmcc,

Let me try first.

Thank you.
Hi  mlmcc,

Some the data has no @.

What should I do  ?

Thank you.
What does it mean when there is no "@"?

 Do you not want to use that string at all?
   --or--
 Do you want to use the whole string as one thing or the other (fmlDesc or fmlQty)?  Which one?  And then just leave the other part blank?
   --or--
 Do you still want to split the string, but using some other character (not "@") as the delimiter?

 James
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great.

Thank you very much for your help.