How do I change "smith james.jpg" to "smithja.jpg"

[Franklin]

I have a last and first name string such as "smith james.jpg" and want to change it to the first four of the last name, and first two of the first name, and removing the space resulting in "smitja.jpg" Some names aren't four letters long, and some people have three parts to their name, but I'm not too worried about those outliers. Thanks for any help. Some examples.

peterson sarah.jpg to petesa.jpg
cox paul.jpg to coxpa.jpg
henderson ariel.jpg to hendar.jpg

[Admin]

Hi , this can be done in Javascript very easily, do you have a commercial license for BRU?
Otherwise you can use a RegEx (1) as well.

Enable v2 tick in RegEx(1) then

Match:
(.)(.)(.)(.)(.*) (.)(.)(.*)
Replace:
$1$2$3$4$6$7

Try it out.

thanks

[therube]

(Actually, that RegEx fails [as has everything I have tried].
Where is Luke when we need him .)


Heh.
While we're at it, in Replace:
is $1 interchangeable with \1 ?

[Admin]

Hi therube, did you try with RegEx version 2? It works for me.

is $1 interchangeable with \1 ?

In V2, yes

[therube]

Code: Select all

did you try with RegEx version 2?

Well yes, I did.
But what I did, at the time & obviously incorrectly, had not worked.

Anyhow, you're right, it does work.