Skip to Content (Press Enter)
2019-03-03 13-55-42
Hothorasman Panjaitan
235Views
5Comments
Solved
How to make a space after 4 characters
Question

Dear All

How to make a space after 4 characters in table list record

Before

NoNameVa Number
1Horas3434454565656767

After

NoNameVa Number
1Horas3434 4545 6565 6767
0
0
04 Sep 2020
Copy Link
2026-02-26 06-29-24
Rahul
 
MVP
Solution

Hi Hothorasman,

Use Substr function-

Substr(TextVar,0,4)+" "+Substr(TextVar,5,9)+" " toher string


Hope this will help you.

Regards

Rahul Sahu

0
0
04 Sep 2020
Copy Link
2019-03-03 13-55-42
Hothorasman Panjaitan

Rahul Sahu wrote:

Hi Hothorasman,

Use Substr function-

Substr(TextVar,0,4)+" "+Substr(TextVar,5,9)+" " toher string


Hope this will help you.

Regards

Rahul Sahu

 Dear Rahul Sahu


Thanks for the attention, this solution works

 

0
0
06 Sep 2020
Copy Link
2024-02-29 20-20-43
JohnGB

Hi,

The easiest way is to create a function which will loop thru it and add a space on the given number of length.

The result is below


Cheers,
JohnB

0
0
04 Sep 2020
Copy Link
2021-06-09 13-39-18
Agno Silveira
 
MVP

Hi Hothorasman,

One way to do this is by using this component, I believe it will help you in several cases,

you can use this component both in editing and in listing.


See how to use in the example below:


Result:


Hope this helps.

Regards!

0
0
04 Sep 2020
Copy Link
2019-03-03 13-55-42
Hothorasman Panjaitan

Thanks All

Rahul Sahu.JohnGB ,Agno Silveira

Best and regards

1
0
06 Sep 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.