Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Splitting up a tab delimited field Post Reply Post New Topic
Author Message
cgauss
Newbie
Newbie


Joined: 19 Jun 2015
Location: United States
Online Status: Offline
Posts: 1
Quote cgauss Replybullet Topic: Splitting up a tab delimited field
     Posted: 30 Jul 2015 at 2:35am
Im trying to split up a tab delimited field for display.  The field is from a Windows event log message and appears to be tab delimited.  An example is at the bottom of this post.

I want to be able to display the second instance of the Account Name.   Been Googling this morning but havent found any sort of definitive answer.

Can anyone help me out?



An account was successfully logged on.    Subject:   Security ID:  S-1-0-0   Account Name:  -   Account Domain:  -   Logon ID:  0x0    Logon Type:   3    New Logon:   Security ID:  S-xxxx   Account Name:  xxxxx   Account Domain:  xxxxx   Logon ID:  0xef8de76   Logon GUID:  {xxxxx}    Process Information:   Process ID:  0x0   Process Name:  -    Network Information:   Workstation Name:    Source Network Address: xxxxx   Source Port:  xxxxx    Detailed Authentication Information:   Logon Process:  Kerberos   Authentication Package: Kerberos   Transited Services: -   Package Name (NTLM only): -   Key Length:  0    This event is generated when a logon session is created. It is generated on the computer that was accessed.    The subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.    The logon type field indicates the kind of logon that occurred. The most common types are 2 (interactive) and 3 (network).    The New Logon fields indicate the account for whom the new logon was created, i.e. the account that was logged on.    The network fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.    The authentication information fields provide detailed information about this specific logon request.   - Logon GUID is a unique identifier that can be used to correlate this event with a KDC event.   - Transited services indicate which intermediate services have participated in this logon request.   - Package name indicates which sub-protocol was used among the NTLM protocols.   - Key length indicates the length of the generated session key. This will be 0 if no session key was requested. 
IP IP Logged
bowja
Newbie
Newbie
Avatar

Joined: 07 Dec 2009
Location: Australia
Online Status: Offline
Posts: 31
Quote bowja Replybullet Posted: 02 Aug 2015 at 8:38pm
Hi there,

Perhaps you create an array with the field and then refer to the position of the items you want?
Try using something like:

Shared Stringvar Array strings:= Split({country_metro.Field1},"  ");

strings[1];

and then for your next field:

Shared Stringvar Array strings;
strings[3];

etc etc
If you think you can or think you can't you are right - Paraphrased quote Henry Ford
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum