How to Split Multiple Strings/Lines into Two Variables

Question

I am attempting to setup a script where it looks inside a file, retrieves the user description, the username, and the date/time that each of the users logged out. From there I would like to export the information into a .csv file. I was able to successfully retrieve the user description & username cleanly, but I am trying to retrieve the date/time so that it can easily be reviewed as well. To do this, I would like to split the value(s) of the date/time so that one variable is just the dates and the other variable is just the times. From there, I should be able to easily export the information to a csv file in 4 columns (user description, username, logout date, & logout time).

Here is the part of the script I'm having an issue with:

#Create Variable for User Description & User ID & Last Logout
[xml]$UserInfoPath = gc $AccountListPath
$UserDescString = $UserInfoPath.AccountList.UserAccount.description
$UserInfoString = $UserInfoPath.AccountList.UserAccount.UserInfo.username
$UserLogoutString = $UserInfoPath.AccountList.UserAccount.UserInfo.LastLogout
$UserLogoutDate,$UserLogoutTime = $UserLogoutString.split("T")

This is the output of the $UserLogoutString variable:

I would like to use the 'T' to split the string on each of the lines so that the $UserLogoutDate variable displays this:

I would like to us the 'T' to split the string on each of the lines so that the $UserLogoutDate variable displays this:

11:06:34.311-06:00
11:09:30.903-06:00
11:06:34.311-06:00
13:15:17.003-06:00
16:10:03.179-06:00

The variables above, however, are not displaying the way I want them to. I am currently seeing this output:

Is $UserLogoutString really a string? can you show us the output from $UserLogoutString.GetType() ? — Santiago Squarzon
– Santiago Squarzon, Commented Feb 1, 2023 at 18:09
Good catch. It turns out that the type is an array. Thank you for pointing that out. — SeveredTRUTH
– SeveredTRUTH, Commented Feb 1, 2023 at 23:13

Santiago Squarzon · Accepted Answer · 2023-02-01 18:41:42Z

1

It's unclear if $UserLogoutString is actually a string or already an array.

Assuming this is an array, -split '\r?\n' wouldn't be needed in code below.

$result = $UserLogoutString -split '\r?\n' | ForEach-Object {
    $date, $time = $_.Split('T')
    @{ $date = $time }
}

$($result.Keys)   # has all the dates
$($result.Values) # has all the times

The following would result in an array of hash tables, then via member access enumeration we can reference all .Keys and .Values in the array.

edited Feb 1, 2023 at 18:41

answered Feb 1, 2023 at 18:22

Santiago Squarzon

65.6k5 gold badges26 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Split Multiple Strings/Lines into Two Variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related