Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Remove a special character during a data extraction

Avatar

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
thibaultb473199
Level 3

13-08-2019

Hello everyone,

I am running a workflow using customers data which will be extract with a data extraction (Excel) and I have some issues with the phone number data which sometimes use a "+" in the beginning of the phone number. (depending on the country)

For example : I have the use of "320123456789" and "+320123456789" for the phone number field.

My request is : is it possible to remove that "+" special character during the data extraction so this character won't be present in my Excel ? If yes, how can I make such a task ? Does this need Javascript ?

If you need more information, feel free to ask.

Thanks in advance.

Kind regards,

View Entire Topic

Avatar

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 10
Level 3
thibaultb473199
Level 3

Likes

25 likes

Total Posts

77 posts

Correct Reply

2 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 25
View profile
thibaultb473199
Level 3

14-08-2019

Hello wodnicki​ ,

Thank you so much for the precision.

I have a last question : I have some phone number data (example : +0032123456789) and I want to use an "if" if this case happen and remove the "+" for this case and else it's another case (example : +32123456789), don't do anything. Is it possible to do that in SQL ? I'm not familiar with that kind of language.

Kind regards,

Thibault