Hey Guys,
I would like to split this string with sapace FR7630003034981231231230061 and get this
FR76 3000 3034 9812 3123 1230 061.
Thanks for ur help.
Regards,
Sam
Hey Guys,
I would like to split this string with sapace FR7630003034981231231230061 and get this
FR76 3000 3034 9812 3123 1230 061.
Thanks for ur help.
Regards,
Sam
There is no spaces here @sam35,
You want to split for each 4 characters?
yes @HareeshMR
yes @HareeshMR i want space between each 4 characters
Hello @sam35
Welcome to the forum!
in case the number of splitted characters is fixed :
splitText= Str.Split(""c)(1).Substring(0,4)
or this
sam35.xaml (11.4 KB)
Basically all I did was this:
If this solved your question, please mark it as solved, don’t forget to like the post.
regards
@beesheep, thanks for your answer the number of splitted characters is fixed i tried the fisrt fuction but it didn’t work, would like t have that string as output (FR76 3000 3034 9812 3123 1230 061) and as input, i have this (FR7630003034981231231230061).
Thanks in advence.