BulldogMike
asked on
telephone number manipulation
Hi
How can I manipulate this string -800-238-7828
to end up with this string (800) 238 7828
Thanks
Mike
How can I manipulate this string -800-238-7828
to end up with this string (800) 238 7828
Thanks
Mike
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, I could have added it, but it's up to Mike to fit the code in. Just mentioned some options...
ASKER
Hi
Maybe I shpuld have shared this with you before - could you indicate how to work you solutions into these statements: the TEM_CBK_PHN_NB and TEM_FAX_NB components are the telephone and fax numbers repectively
@ProperCase(PHP_ADR_LN1) + ", " + @ProperCase(LOC_CD) +
@NewLine + @ProperCase(PHP_ADR_LN2) +
@NewLine + TEM_CBK_PHN_NB +
@NewLine + TEM_FAX_NB + " " + "Fax"
Thank you for your help. it looks like you all will get points on this one
Mike
Maybe I shpuld have shared this with you before - could you indicate how to work you solutions into these statements: the TEM_CBK_PHN_NB and TEM_FAX_NB components are the telephone and fax numbers repectively
@ProperCase(PHP_ADR_LN1) + ", " + @ProperCase(LOC_CD) +
@NewLine + @ProperCase(PHP_ADR_LN2) +
@NewLine + TEM_CBK_PHN_NB +
@NewLine + TEM_FAX_NB + " " + "Fax"
Thank you for your help. it looks like you all will get points on this one
Mike
As I expected: formula :-)
Instructions?
You take the keyboard, you type the I, then the .... C'mon man, think and try by yourself first!
Hint --- add these lines at least once:
tel:= @Trim(@Split(TEM_CBK_PHN_N B; "-"));
telf:= "(" + tel[1] + ") " + tel[2] + " " + tel[3];
and use telf instead of TEM_CBK_PHN_NB
Instructions?
You take the keyboard, you type the I, then the .... C'mon man, think and try by yourself first!
Hint --- add these lines at least once:
tel:= @Trim(@Split(TEM_CBK_PHN_N
telf:= "(" + tel[1] + ") " + tel[2] + " " + tel[3];
and use telf instead of TEM_CBK_PHN_NB
ASKER
Sorry Seif
I am a healthcare professional and a novice programmer at best - I learn to program by reading books and doing it on the job. This is basic stuff for you but it's Greek to me since I lack formal IT training
Thanks
Mike
I am a healthcare professional and a novice programmer at best - I learn to program by reading books and doing it on the job. This is basic stuff for you but it's Greek to me since I lack formal IT training
Thanks
Mike
ASKER
Apparently @ SPLIT is not an available function in Notes 5.0
Should I use @ left or @middle to parse the data as an alternative?
Thank You
Mike
Should I use @ left or @middle to parse the data as an alternative?
Thank You
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As always these experts are very helpful.
x= Split(orig, "-")
conv= "(" + x(1) + ") " + x(2) + " " + x(3)
If you want to accept multiple input formats, have a look at Regex:
http://www.regular-expressions.info/vb.html
If you want it in formula language:
x:= @Trim(@Split(orig; "-"));
conv:= "(" + x[1] + ") " + x[2] + " " + x[3];