Ability to create usernames from full names.

sysmicuser · 12-12-2013, 11:43 PM

Hi Gurus,

I want to create usernames from a file which has list of name in a format like

firstname lastname frstname1 lastname1 firstname lastname2

and output should be like something this
flastname;flastname1;flastname2

How can we get around with this ?

Ygrex · 12-13-2013, 02:24 AM

hi,

to have all letters different I got this line instead:
'First Alpha Second Beta Third Omega Four'

Code:

$ echo 'First Alpha Second Beta Third Omega Four' | ( sep='' ; tr ' ' '\n' | while read first && read second ; do printf '%s%s%s' "$div" "$(printf '%s' "$first" | dd count=1 bs=1 2>/dev/null)" "$second" ; div=';' ; done ; echo )

FAlpha;SBeta;TOmega

grail · 12-13-2013, 03:57 AM

And what have you tried and where are you stuck?

Assuming set order this would seem to be rather easy in most languages.

If however the order of first and last names is possibly unknown this would be increasingly more difficult and you will need some form of identifier.

druuna · 12-13-2013, 04:19 AM

The uniqueness of the created usernames should also be checked.

Code:

john smith jackie smith jill smith

All the above would end up as jsmith, which is probably not what you want.

Madhu Desai · 12-13-2013, 04:26 AM

Code:

awk '{print $1";"$3";"$5}' file

druuna · 12-13-2013, 04:45 AM

@mddesai: That only prints 3 first names and not first letter of first name combined with the last name for all entries in the line.

I had a quick go at it and came up with this (using a ksh shebang, a bash shebang can be used with bash 4+):

Code:

#!/bin/ksh

typeset -A uName

while read LINE
do
  nameArr=( ${LINE} )
  for (( x=0; x<${#nameArr[@]}; x=x+2 ))
  do
    tmpName="${nameArr[x]:0:1}${nameArr[x+1]}"
    [[ "${uName[$tmpName]}" != "" ]] && tmpName="${tmpName}$x"
    uName[$tmpName]="seen"
    echo -n "${tmpName};"
  done
  echo 
done < infile #> outfile

Madhu Desai · 12-13-2013, 05:28 AM

Quote:

Originally Posted by druuna

@mddesai: That only prints 3 first names and not first letter of first name combined with the last name for all entries in the line.

Oh! Ok...

Then how about this...

Code:

$ cat names
Amitabh Bachchan Tom Hanks Brad Pitt
Deepika Padukone Anne Hathaway Priyanka Chopra 

$ awk '{print substr($1,0,1)$2";"substr($3,0,1)$4";"substr($5,0,1)$6}' names
ABachchan;THanks;BPitt
DPadukone;AHathaway;PChopra

druuna · 12-13-2013, 06:10 AM

@mddesai:
1 - I do believe the OP gave a rough example to explain the format. The amount of first/last names on a line is unknown and probably not limited to 3 pairs.

2 - What about the possible none unique entries that might be created.

grail · 12-13-2013, 07:23 AM

Well I like druuna's idea, but I thought I would keep all counts starting at 1.

So infile used:

Code:

john smith jackie smith jill smith
Amitabh Bachchan Tom Hanks Brad Pitt
Deepika Padukone Anne Bachchan Priyanka Chopra

Code:

#!/bin/bash

declare -A uName

while read -a LINE
do
	for (( x = 0; x < ${#LINE[*]}; x += 2 ))
	do
		(( x > 0 )) && echo -n ";"
		tname="${LINE[x]:0:1}${LINE[x+1]}"
		(( (( c = uName[$tname]++ )) > 0 )) || c=""
		echo -n $tname$c
	done
	echo
done<infile

Output:

Code:

jsmith;jsmith1;jsmith2
ABachchan;THanks;BPitt
DPadukone;ABachchan1;PChopra

GazL · 12-13-2013, 07:41 AM

Don't forget those awkward Irish folk who insist in having apostrophes in their names either. And those pretentious double-barreled handles the posh folk tend to use.

<Initial><Surname> format login names is just all-round problematic and imo best avoided. If Patrick McGoohan had a login on one of my boxes I can tell you he'd be "user6" no matter how much he protested that "he wasn't a number"!

Ygrex · 12-13-2013, 09:45 AM

druuna,

Code:

$ echo 'First Alpha Second Beta Third Omega Four' | ksh devel/ksh.ksh 
devel/ksh.ksh[3]: typeset: -A: unknown option
devel/ksh.ksh[8]: syntax error: '((' unexpected

I think this is common problem with bashisms

Code:

$ ksh -c 'echo $KSH_VERSION'
@(#)MIRBSD KSH R46 2013/05/02

druuna · 12-13-2013, 10:28 AM

Quote:

Originally Posted by Ygrex

druuna,

Code:

$ echo 'First Alpha Second Beta Third Omega Four' | ksh devel/ksh.ksh 
devel/ksh.ksh[3]: typeset: -A: unknown option
devel/ksh.ksh[8]: syntax error: '((' unexpected

I think this is common problem with bashisms

Code:

$ ksh -c 'echo $KSH_VERSION'
@(#)MIRBSD KSH R46 2013/05/02

I'm not sure what your are trying to do. The script I posted uses a file as input (called infile). It is not build to except input from outside the script as shown by you.

The ksh used by me is the "original" Korn shell by AT&T, also known as ksh93:

Code:

ksh --version
  version         sh (AT&T Research) 93s+ 2008-01-31

Trying to use pdksh, for example, will not work as it doesn't know the -A typeset option (or in other words: doesn't allow associative arrays).

If you have a bash 4+ version on your machine you can use that as well (do change the shebang in my script). Older bash versions also cannot use associative arrays.

Ygrex · 12-13-2013, 12:52 PM

that is why I tend to stick on POSIX if requirements are not clear enough, i.e. for all newbie questions

sysmicuser · 12-15-2013, 08:18 AM

@ Thank you to all.

@Ygrex

I tested the script which you have given and it works for all except when a name is like this firstname pe lastname or firstname de lastname and those weird name which have commas

say firstname o'lastname any idea if we can get around with that or rather add them manually in system ?

schneidz · 12-15-2013, 08:54 AM

Code:

cat sysmicuser.lst | tr "'" "-"