Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table Transformer
thousand-separator
dateFormatdd M yy
export-wordtrue
decimals
show-sourcetrue
export-csvtrue
id1570720467797_-1990416506
worklog5|8|w d h m|w d h m
join-column#
separator.
export-pdftrue
sqlSELECT rownum() as Nbr, length(Name) as Length, Name as Full_Name, @posA = 1, instr(Name,char(32))-1 As valA, cast(@posA as integer)-1 as start_point, substring(Name,1,posA-1) as first_name, substring(Name,@pos1+1,@length-@pos1+1) as last_name, instr(Name,char(32)) as posB, substring(Name,1,(instr(Name,char(32))-1)) AS Name_First, substring(Name,(instr(Name,char(32))+1),(length(Name)-(instr(Name,char(32),-1))+1)) AS Name_Last, E-mail, Phone FROM T1 ORDER by Name_Last, Name_First


#PresentNameE-mailPhone
1
  •   


2
  •   


3
  •   


4
  •   


5
  •   


6
  •   


7
  •   


8
  •   


9
  •   


10
  •   


11
  •   


12
  •   


13
  •   

Ryan Clark

clark@ncqa.org
14
  •   


15
  •   
rita.altamore@doh.wa.gov
16
  •   


17
  •   


18
  •   


19
  •   


20
  •   


21
  •   
david.deroode@lantanagroup.com
22
  •   


23
  •   


24
  •   
becky.angeles@carradora.com
25
  •   

@Michael Tyburski

michael.tyburski@ssa.gov
26
  •   


27
  •   


28
  •   
@Matt S

mszczepa@epic.com


29
  •   


30
  •   


31
  •   
lhoggle@irishealthsolutions.com
32
  •   
gdolin@imo-online.com
33
  •   
landerson@ncqa.org
34
  •   
avinash.shanbhag@hhs.gov
35
  •   
rmcclure@mdpartners.com
36
  •   
tmk000@gmail.com
37
  •   
craig.newman@altarum.org
38
  •   

martha.velezis@fda.hhs.gov

marti.

velezis@gmail

velezis@sonrisaconsulting.com


39
  •   
drew.torres@cerner.com
40
  •   




...